/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50562
 Source Host           : 127.0.0.1:3306
 Source Schema         : spring-guest

 Target Server Type    : MySQL
 Target Server Version : 50562
 File Encoding         : 65001

 Date: 19/02/2022 09:52:28
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for guest
-- ----------------------------
DROP TABLE IF EXISTS `guest`;
CREATE TABLE `guest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` varchar(255) DEFAULT NULL,
  `uid` int(10) DEFAULT NULL,
  `create_time` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of guest
-- ----------------------------
BEGIN;
INSERT INTO `guest` VALUES (1, '这是测试留言啦', 6, 1630913046);
INSERT INTO `guest` VALUES (2, '啦啦啦', 1, 1630915899);
INSERT INTO `guest` VALUES (3, 'SpringMVC V1.0.0', 1, 1630923413);
INSERT INTO `guest` VALUES (4, '测试内容哈', 1, 1636982013);
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user` varchar(40) DEFAULT NULL,
  `pass` varchar(40) DEFAULT NULL,
  `name` varchar(40) DEFAULT NULL COMMENT '名称',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `sex` tinyint(1) DEFAULT '0' COMMENT '性别 1男 2女',
  `skill` varchar(255) DEFAULT NULL COMMENT '技能',
  `create_time` int(10) DEFAULT '0' COMMENT '注册时间',
  `last_time` int(10) DEFAULT NULL COMMENT '登录时间',
  `perms` varchar(100) DEFAULT NULL COMMENT '权限',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES (1, 'admin', 'admin', '张三', '/upload/qrcode.png', 2, 'Java,PHP,JavaScript,Python,Go', 0, 1636985467, 'user:add');
INSERT INTO `users` VALUES (2, 'test', '123456', NULL, NULL, NULL, NULL, 1630911688, NULL, 'user:update');
INSERT INTO `users` VALUES (3, 'colin', '123456', NULL, NULL, NULL, NULL, 1630911689, NULL, 'user:add,user:update');
INSERT INTO `users` VALUES (4, '张三', '123456', NULL, NULL, NULL, NULL, 1630911900, NULL, NULL);
INSERT INTO `users` VALUES (5, '李斯', '123456', NULL, NULL, NULL, NULL, 1630911986, NULL, NULL);
INSERT INTO `users` VALUES (6, '王五', '123456', NULL, NULL, NULL, NULL, 1630912090, NULL, NULL);
INSERT INTO `users` VALUES (7, 'test1', '123456', NULL, NULL, 0, NULL, 1636983121, 1636983121, NULL);
INSERT INTO `users` VALUES (8, 'test2', '123456', NULL, NULL, 0, NULL, 1636983370, 1636983370, NULL);
INSERT INTO `users` VALUES (9, 'test3', '123456', NULL, NULL, 0, NULL, 1636983435, 1636983435, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
